Python Job: BI Analyst

The future of energy is digitised, decarbonised and localised. At Smartest Energy, we need revolutionary thinkers to help our customers make the most of this new landscape, thinking differently to find smart solutions to complex problems.

Formed in 2001, we’re an agile business driven by entrepreneurial thinking. As a subsidiary of the Marubeni Corporation, we also have strong investment and infrastructure behind us. We have three offices in the UK, one in the US and another in Australia. Further expansion is planned for 2022 and beyond which means global career opportunities for you, with plenty of potential to explore new markets.

Flexibility is vital to success in our business and many of our staff work flexibly in many different ways, including part-time, compressed hours, remotely or a mix of remote/office. Please talk to us about what flexibility means to you and don’t let anything stop you from applying.

When you join our Team, you will have the opportunity to contribute and make an impact every single day.

Overview

We have an exciting opportunity for a Business Intelligence (BI) Analyst to join our Finance team. This is a newly created role to support the growth of the business and to ensure our team focus on financial control, planning and providing excellent customer experience to our stakeholders is maintained.

In this role you will be responsible for enhancing business insights for the Finance team through automation of reporting and data insights using information available in our data warehouse and other core operational systems. A key aspect of the role will be to develop robust data organisation and management that underpins the Finance functions and in doing so understanding the data setup and data process flows between our core Retail, Risk, IT and Finance Systems. Key expected outputs will be efficiencies with obtaining accurate (reconciled) and meaningful concise data for financial reporting purposes.

As SmartestEnergy Australia is a start-up energy business, this role will suit someone who is open to performing a variety of ad hoc tasks, who enjoys a fast-paced environment and can multitask, is keen on financial reporting and reconciliation improvements, and enjoys working with a variety of internal stakeholders.

As this role sits within the Finance team, an understanding of basic accounting principles will be advantageous.

In this role, you will be involved with the following:

Monthly reporting automation

• Improve and automate the processes by which month end reporting data is received by the Finance team into a readily useable reconciled format. This includes consumption of the core customer contract data, along with other key valuation data used in our top line reporting;
• Build exception reports to allow for efficient analysis and insights into drivers of movements and variances;
• Work closely with the Risk, IT and Commercial teams to understand the data source location and queries used to generate core information received and used by Finance for month end reporting, and document key source data tables and queries used;
• Data extraction and other miscellaneous reporting and reconciliation improvements as requested.

Finance system design improvements

• Assist with scoping and redesigning the entity and structure setup in our general ledger system, working closely under direction of the Finance team, including performing the transfer and reconciliation checks of data;
• between such entities and reporting periods as redesigned;
• Build new useful reports in/from our general ledger system.

Dashboards and analytics

• Build useful Finance dashboards, with key metrics and performance trackers, using Power BI and other analytical/visualisation tools.

Other/Ad-Hoc

• Perform ad-hoc tasks as directed, such as population of templates with financial data both historic and forecast, perform data analysis on variances between risk and finance reporting, create data dictionaries for finance purposes and document processes and policies as needed.
  

To be successful in this role, you are likely to have the following skills/experience:

• Energy industry experience is preferred, but not essential;
• Relevant tertiary qualifications;
• Previous experience in a similar role eg business intelligence analyst, data analyst, data scientist, financial reporting or business analyst;
• Ability to interpret large amounts of complex data and utilise experience to make decisions when information is incomplete or inaccurate;
• Experience in obtaining and concisely documenting user requirements and actioning those in a timely manner;
• Strong technical skills; knowledge and experience working with technologies such as Python, Excel, VBA, SQL;
• Experience in preparing dashboards and powerpoint presentations;
• Experience with Salesforce, EnergyOne, Tally or Xero advantageous, but not essential.

What else do we offer?

• A genuine commitment to smarter working – we recognise your work/life balance matters;
• Excellent compensation package;
• Open and inclusive work culture to bring your best self to work;
• Career development and learning opportunity;
• Role can be based in Sydney or Melbourne;

Diversity

We know that for our business to thrive we need diverse talent with a range of backgrounds, skills and capabilities in each of the countries in which we operate. We view diversity as one of the key enablers that helps our business to grow.

Celebrating our inclusive and diverse culture is core to what we do. We value everybody irrespective of background, disability, religion, gender identity, sexuality or ethnicity.

• Check out all our current open positions
• Our privacy policy is here